inherited frmStockQuery: TfrmStockQuery
  Width = 910
  Height = 517
  Caption = #24211#23384#26597#35810
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlData: TPanel [0]
    Align = alNone
  end
  inherited rzszpnlSelect: TRzSizePanel [1]
    Width = 902
    inherited lblSearch: TLabel
      Left = 223
      Top = 10
    end
    object lblStorageID: TLabel [1]
      Left = 16
      Top = 10
      Width = 36
      Height = 12
      Caption = #20179#20648#20301
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlue
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
    end
    inherited edtSearch: TEdit
      Left = 271
      Top = 7
      ParentFont = False
    end
    object cxcbbSTORAGE_ID: TcxLookupComboBox
      Left = 52
      Top = 6
      Properties.DropDownAutoSize = True
      Properties.DropDownListStyle = lsFixedList
      Properties.KeyFieldNames = 'STORAGE_ID'
      Properties.ListColumns = <
        item
          FieldName = 'ZJM'
        end
        item
          FieldName = 'STORAGE_NM'
        end>
      Properties.ListFieldIndex = 1
      Properties.ListSource = dsSTORAGE
      TabOrder = 1
      Width = 145
    end
  end
  inherited rzszpnlTree: TRzSizePanel [2]
    Width = 902
    Height = 445
    Align = alClient
    inherited cxpgcntrlTree: TcxPageControl
      Width = 902
      Height = 445
      ClientRectBottom = 445
      ClientRectRight = 902
      ClientRectTop = 23
      inherited ctsTree: TcxTabSheet
        TabVisible = False
        inherited cdbtlTree: TcxDBTreeList
          Width = 902
          Height = 422
        end
      end
      inherited ctsGrid: TcxTabSheet
        inherited cxgrdTree: TcxGrid
          Width = 902
          Height = 422
          inherited cxgrdbtblvwTree: TcxGridDBTableView
            DataController.DataSource = dsData
            DataController.KeyFieldNames = 'MAT_ID'
            OptionsData.Editing = True
            object cxgrdbtblvwTreeSTORAGE_ID: TcxGridDBColumn
              DataBinding.FieldName = 'STORAGE_ID'
              PropertiesClassName = 'TcxLookupComboBoxProperties'
              Properties.DropDownAutoSize = True
              Properties.DropDownListStyle = lsFixedList
              Properties.KeyFieldNames = 'STORAGE_ID'
              Properties.ListColumns = <
                item
                  FieldName = 'ZJM'
                end
                item
                  FieldName = 'STORAGE_NM'
                end>
              Properties.ListFieldIndex = 1
              Properties.ListSource = dsSTORAGE
              HeaderAlignmentHorz = taCenter
            end
            object cxgrdbtblvwTreeMAT_ID: TcxGridDBColumn
              DataBinding.FieldName = 'MAT_ID'
              Visible = False
              HeaderAlignmentHorz = taCenter
            end
            object cxgrdbtblvwTreemat_no: TcxGridDBColumn
              DataBinding.FieldName = 'mat_no'
              HeaderAlignmentHorz = taCenter
            end
            object cxgrdbtblvwTreemat_nm: TcxGridDBColumn
              DataBinding.FieldName = 'mat_nm'
              HeaderAlignmentHorz = taCenter
              Width = 239
            end
            object cxgrdbtblvwTreeunit_nm: TcxGridDBColumn
              DataBinding.FieldName = 'unit_nm'
              HeaderAlignmentHorz = taCenter
              Width = 56
            end
            object cxgrdbtblvwTreePRE_QTY: TcxGridDBColumn
              DataBinding.FieldName = 'PRE_QTY'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
            object cxgrdbtblvwTreePRE_AMOUNT: TcxGridDBColumn
              DataBinding.FieldName = 'PRE_AMOUNT'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
            object cxgrdbtblvwTreeIN_QTY: TcxGridDBColumn
              DataBinding.FieldName = 'IN_QTY'
              HeaderAlignmentHorz = taCenter
              Width = 83
            end
            object cxgrdbtblvwTreeIN_AMOUNT: TcxGridDBColumn
              DataBinding.FieldName = 'IN_AMOUNT'
              HeaderAlignmentHorz = taCenter
              Width = 95
            end
            object cxgrdbtblvwTreeOUT_QTY: TcxGridDBColumn
              DataBinding.FieldName = 'OUT_QTY'
              HeaderAlignmentHorz = taCenter
              Width = 83
            end
            object cxgrdbtblvwTreeOUT_AMOUNT: TcxGridDBColumn
              DataBinding.FieldName = 'OUT_AMOUNT'
              HeaderAlignmentHorz = taCenter
              Width = 95
            end
            object cxgrdbtblvwTreeLAST_QTY: TcxGridDBColumn
              DataBinding.FieldName = 'LAST_QTY'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
            object cxgrdbtblvwTreeLAST_AMOUNT: TcxGridDBColumn
              DataBinding.FieldName = 'LAST_AMOUNT'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
            object cxgrdbtblvwTreePRICE: TcxGridDBColumn
              DataBinding.FieldName = 'PRICE'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
            object cxgrdbtblvwTreeSJ_QTY: TcxGridDBColumn
              Tag = 3
              DataBinding.FieldName = 'SJ_QTY'
              PropertiesClassName = 'TcxTextEditProperties'
              HeaderAlignmentHorz = taCenter
              Width = 71
            end
          end
        end
      end
    end
  end
  inherited adsData: TADODataSet
    CursorType = ctStatic
    CommandText = 
      'select a.*, b.mat_no, b.mat_nm, c.unit_nm'#13#10'  from stock a, matm ' +
      'b, unit c'#13#10' where a.mat_id = b.mat_id'#13#10'   and b.unit_id = c.unit' +
      '_id'#13#10'   and 1 = 0'#13#10' order by b.mat_no'
    object adsDataSTORAGE_ID: TLargeintField
      FieldName = 'STORAGE_ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
    end
    object adsDataMAT_ID: TLargeintField
      FieldName = 'MAT_ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
    end
    object adsDataPRE_QTY: TBCDField
      FieldName = 'PRE_QTY'
      Precision = 18
      Size = 2
    end
    object adsDataPRE_AMOUNT: TBCDField
      FieldName = 'PRE_AMOUNT'
      Precision = 18
      Size = 2
    end
    object adsDataIN_QTY: TBCDField
      FieldName = 'IN_QTY'
      Precision = 18
      Size = 2
    end
    object adsDataIN_AMOUNT: TBCDField
      FieldName = 'IN_AMOUNT'
      Precision = 18
      Size = 2
    end
    object adsDataOUT_QTY: TBCDField
      FieldName = 'OUT_QTY'
      Precision = 18
      Size = 2
    end
    object adsDataOUT_AMOUNT: TBCDField
      FieldName = 'OUT_AMOUNT'
      Precision = 18
      Size = 2
    end
    object adsDataLAST_QTY: TBCDField
      FieldName = 'LAST_QTY'
      Precision = 18
      Size = 2
    end
    object adsDataLAST_AMOUNT: TBCDField
      FieldName = 'LAST_AMOUNT'
      Precision = 18
      Size = 2
    end
    object adsDataPRICE: TBCDField
      FieldName = 'PRICE'
      Precision = 18
      Size = 2
    end
    object adsDataSJ_QTY: TBCDField
      FieldName = 'SJ_QTY'
      Precision = 18
      Size = 2
    end
    object adsDataMAT_NO: TStringField
      FieldName = 'MAT_NO'
      ProviderFlags = []
    end
    object adsDataMAT_NM: TStringField
      FieldName = 'MAT_NM'
      ProviderFlags = []
      Size = 50
    end
    object adsDataUNIT_NM: TStringField
      FieldName = 'UNIT_NM'
      ProviderFlags = []
    end
  end
  inherited dspData: TDataSetProvider
    Options = [poAllowCommandText]
    UpdateMode = upWhereKeyOnly
  end
  inherited cdsData: TClientDataSet
    object cdsDataSTORAGE_ID: TLargeintField
      DisplayLabel = #20179#20648#20301
      FieldName = 'STORAGE_ID'
    end
    object cdsDataMAT_ID: TLargeintField
      FieldName = 'MAT_ID'
    end
    object cdsDataPRE_QTY: TBCDField
      DisplayLabel = #19978#26399#25968#37327
      FieldName = 'PRE_QTY'
      Precision = 18
      Size = 2
    end
    object cdsDataPRE_AMOUNT: TBCDField
      DisplayLabel = #19978#26399#37329#39069
      FieldName = 'PRE_AMOUNT'
      Precision = 18
      Size = 2
    end
    object cdsDataOUT_QTY: TBCDField
      DisplayLabel = #26412#26399#20986#24211#25968
      FieldName = 'OUT_QTY'
      Precision = 18
      Size = 2
    end
    object cdsDataOUT_AMOUNT: TBCDField
      DisplayLabel = #26412#26399#20986#24211#37329#39069
      FieldName = 'OUT_AMOUNT'
      Precision = 18
      Size = 2
    end
    object cdsDataIN_QTY: TBCDField
      DisplayLabel = #26412#26399#20837#24211#25968
      FieldName = 'IN_QTY'
      Precision = 18
      Size = 2
    end
    object cdsDataIN_AMOUNT: TBCDField
      DisplayLabel = #26412#26399#20837#24211#37329#39069
      FieldName = 'IN_AMOUNT'
      Precision = 18
      Size = 2
    end
    object cdsDataLAST_QTY: TBCDField
      DisplayLabel = #26031#26411#25968#37327
      FieldName = 'LAST_QTY'
      Precision = 18
      Size = 2
    end
    object cdsDataLAST_AMOUNT: TBCDField
      DisplayLabel = #26399#26411#37329#39069
      FieldName = 'LAST_AMOUNT'
      Precision = 18
      Size = 2
    end
    object cdsDataPRICE: TBCDField
      DisplayLabel = #24179#22343#21333#20215
      FieldName = 'PRICE'
      Precision = 18
      Size = 2
    end
    object cdsDatamat_no: TStringField
      DisplayLabel = #29289#26009#32534#21495
      FieldName = 'mat_no'
    end
    object cdsDatamat_nm: TStringField
      DisplayLabel = #29289#26009#21517#31216
      FieldName = 'mat_nm'
      Size = 50
    end
    object cdsDataunit_nm: TStringField
      DisplayLabel = #21333#20301
      FieldName = 'unit_nm'
    end
    object cdsDataSJ_QTY: TBCDField
      DisplayLabel = #23454#30424#25968#37327
      FieldName = 'SJ_QTY'
      Precision = 18
      Size = 2
    end
  end
  object adsSTORAGE: TADODataSet
    Connection = DM.conApp
    CursorType = ctStatic
    LockType = ltReadOnly
    CommandText = 
      'select STORAGE_ID, STORAGE_NM, ZJM from STORAGE order by STORAGE' +
      '_ID'
    Parameters = <>
    Left = 184
    Top = 141
    object adsSTORAGESTORAGE_ID: TLargeintField
      DisplayLabel = 'ID'
      FieldName = 'STORAGE_ID'
    end
    object adsSTORAGESTORAGE_NM: TStringField
      DisplayLabel = #20179#20648#20301
      FieldName = 'STORAGE_NM'
    end
    object adsSTORAGEZJM: TStringField
      DisplayLabel = #21161#35760#30721
      FieldName = 'ZJM'
      Size = 10
    end
  end
  object dsSTORAGE: TDataSource
    DataSet = adsSTORAGE
    Left = 216
    Top = 141
  end
end
